Spring JPA with pageable and subquery causing query syntax error

0:01:48

Resolving the Spring JPA Query Syntax Error with Pagination and Subqueries

0:15:05

@Formula in Hibernate | Compute derive field dynamically | @Formula in Spring boot JPA